
/*
Project: 		The Impact of Short-Term Employment for Low-Income Youth: Experimental 	
				Evidence from the Philippines
Authors: 		Emily A. Beam and Stella Quimbo

***********************************
Path: 			code/02_analysis
File name: 		table_a11.do 
***********************************

Purpose: 		Generates Appendix Table A11

Inputs: 		spes_data.dta
Outputs: 		table_a11.tex

Log: 			results/03_output/log_table_a11.log		

Last updated: 	18 November 2021
*/ 





cap log close 
log using "$output/log_table_a11.log",replace

loc filename "beamquimbo_tables"

use "$usedata_analysis/spes_data",clear 


// Output results
putexcel set "$tables_analysis/`filename'.xlsx",  sheet(Table A11,replace) modify

	decode _eeo_work_now_positioncode,gen(_position_recode)
	levelsof _position_recode, local(r_labels)


	tab  _position_recode, matcell(cellcounts) 

matrix rownames cellcounts = `r_labels'

putexcel A1 = matrix(cellcounts), names

log close 
exit
